package com.trkj.dao.hjj;

import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojo.Affairtypeconfirm;
/**
 * 加班确认
 * @author HJJ
 *
 */
public interface WorkOvertimeToConfirm extends CrudRepository<Affairtypeconfirm, Long>{
	@Query("select a,s,af from Affairtypeconfirm a inner join a.staffInformation s inner join a.affaircategory af where af.affcaId=3")
	public List<Object[]> findAllWorkOvertimeToConfirms(Pageable p);
}
